The issue is that your date is formatted at dd/mm/yyyy and SQL Server expects it as mm/dd/yyyy. In fact, if you do this it will succeed: ... <看更多>

This video talks aboutConvert function in SQLSQL convert, cast functionssql convert datetime to datesql ... ... <看更多>

There is no method to directly convert this value because SQL implicitly assumes the first two characters are the year when directly ... ... <看更多>